USE mseconfig;

CREATE TABLE `parameters` (
  `PARKOMPGRP` varchar(16) NOT NULL COMMENT 'Componentgroup of the parameter',
  `PARGRP` varchar(16) NOT NULL COMMENT 'Parametergroup within the component',
  `PARKEY` varchar(16) NOT NULL COMMENT 'Parameter key',
  `PARVALUE` varchar(254) NOT NULL,
  `PARVALUEMIN` varchar(254) DEFAULT NULL,
  `PARVALUEMAX` varchar(254) DEFAULT NULL,
  `PARDESCRIPTION` varchar(80) DEFAULT NULL,
  `PARINFO` varchar(2000) DEFAULT NULL,
  `DTINS` datetime NOT NULL,
  `DTUPD` datetime NOT NULL,
  `NAMUPD` varchar(35) NOT NULL,
  `TSN` decimal(9,0) NOT NULL,
  PRIMARY KEY (`PARKOMPGRP`,`PARGRP`,`PARKEY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','LoginServer','ClientUDPPort','0','0','5055','UPD-Port for Clients','UPD-Port for Clients','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','LoginServer','ConRetInt','5','0','10','Connection retry interval','Connection retry interval','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','LoginServer','IPAddress','127.0.0.1','0.0.0.0','255.255.240.0','IPAddress of MasterServer','IPAddress of MasterServer','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','LoginServer','IsMasterServer','false','false','true','Is this the MasterServer','Is this the MasterServer','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','LoginServer','LocalIPAddress','0.0.0.0','0.0.0.0','255.255.240.0','Local IPAddress','Local IPAddress','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','LoginServer','LocalPort','0','0','65000','Local Port','Local Port','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','LoginServer','MasterUDPPort','4520','4520','4520','UDP-Port for SubServer','UDP-Port for SubServer','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','LoginServer','MaxRetries','5','0','5','Max number if con retries','Max number if con retries','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','LoginServer','ServerName','LoginServer','{null}',null,'Name of the Realm','Name of the Realm the Server manages','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','MasterServer','ClientUDPPort','5055','5055','5055','UPD-Port for Clients','UPD-Port for Clients','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','MasterServer','ConRetInt','0','0','10','Connection retry interval','Connection retry interval','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','MasterServer','IPAddress','127.0.0.1','0.0.0.0','255.255.240.0','IPAddress of MasterServer','IPAddress of MasterServer','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','MasterServer','IsMasterServer','true','false','true','Is this the MasterServer','Is this the MasterServer','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','MasterServer','LocalIPAddress','0.0.0.0','0.0.0.0','255.255.240.0','Local IPAddress','Local IPAddress','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','MasterServer','LocalPort','0','0','65000','Local Port','Local Port','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','MasterServer','MasterUDPPort','4520','4520','4520','UDP-Port for SubServer','UDP-Port for SubServer','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','MasterServer','MaxRetries','0','0','5','Max number if con retries','Max number if con retries','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','MasterServer','ServerName','MasterServer','{null}',null,'Name of the Realm','Name of the Realm the Server manages','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','TestRealm1','ClientUDPPort','5056','0','5055','UPD-Port for Clients','UPD-Port for Clients','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','TestRealm1','ConRetInt','5','0','10','Connection retry interval','Connection retry interval','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','TestRealm1','IPAddress','127.0.0.1','0.0.0.0','255.255.240.0','IPAddress of MasterServer','IPAddress of MasterServer','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','TestRealm1','IsMasterServer','false','false','true','Is this the MasterServer','Is this the MasterServer','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','TestRealm1','LocalIPAddress','0.0.0.0','0.0.0.0','255.255.240.0','Local IPAddress','Local IPAddress','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','TestRealm1','LocalPort','0','0','65000','Local Port','Local Port','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','TestRealm1','MasterUDPPort','4520','4520','4520','UDP-Port for SubServer','UDP-Port for SubServer','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','TestRealm1','MaxRetries','5','0','5','Max number if con retries','Max number if con retries','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
insert into `parameters`(`PARKOMPGRP`,`PARGRP`,`PARKEY`,`PARVALUE`,`PARVALUEMIN`,`PARVALUEMAX`,`PARDESCRIPTION`,`PARINFO`,`DTINS`,`DTUPD`,`NAMUPD`,`TSN`) values ('Server','TestRealm1','ServerName','TestRealm','{null}',null,'Name of the Realm','Name of the Realm the Server manages','2016-02-19 13:14:00','2016-02-19 13:14:00','Init',1);
